happy.raw.analysis

Dataset statistics

Number of variables	11
Number of observations	284807
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	19335
Duplicate rows (%)	6.8%
Total size in memory	23.9 MiB
Average record size in memory	88.0 B

Variable types

Numeric	11

Alerts

Dataset has 19335 (6.8%) duplicate rows	Duplicates
`u` is highly correlated with `g` and 6 other fields	High correlation
`g` is highly correlated with `u` and 8 other fields	High correlation
`r` is highly correlated with `u` and 8 other fields	High correlation
`i` is highly correlated with `u` and 7 other fields	High correlation
`z` is highly correlated with `u` and 7 other fields	High correlation
`uErr` is highly correlated with `u` and 4 other fields	High correlation
`gErr` is highly correlated with `u` and 8 other fields	High correlation
`rErr` is highly correlated with `u` and 8 other fields	High correlation
`iErr` is highly correlated with `g` and 6 other fields	High correlation
`zErr` is highly correlated with `g` and 6 other fields	High correlation
`u` is highly correlated with `g` and 3 other fields	High correlation
`g` is highly correlated with `u` and 3 other fields	High correlation
`r` is highly correlated with `u` and 3 other fields	High correlation
`i` is highly correlated with `u` and 3 other fields	High correlation
`z` is highly correlated with `u` and 3 other fields	High correlation
`uErr` is highly correlated with `gErr` and 1 other fields	High correlation
`gErr` is highly correlated with `uErr` and 1 other fields	High correlation
`rErr` is highly correlated with `uErr` and 1 other fields	High correlation
`u` is highly correlated with `g` and 2 other fields	High correlation
`g` is highly correlated with `u` and 5 other fields	High correlation
`r` is highly correlated with `g` and 6 other fields	High correlation
`i` is highly correlated with `g` and 6 other fields	High correlation
`z` is highly correlated with `g` and 6 other fields	High correlation
`uErr` is highly correlated with `u` and 1 other fields	High correlation
`gErr` is highly correlated with `u` and 7 other fields	High correlation
`rErr` is highly correlated with `g` and 6 other fields	High correlation
`iErr` is highly correlated with `r` and 5 other fields	High correlation
`zErr` is highly correlated with `r` and 4 other fields	High correlation
`u` is highly correlated with `g` and 6 other fields	High correlation
`g` is highly correlated with `u` and 6 other fields	High correlation
`r` is highly correlated with `u` and 6 other fields	High correlation
`i` is highly correlated with `u` and 3 other fields	High correlation
`z` is highly correlated with `u` and 3 other fields	High correlation
`uErr` is highly correlated with `u` and 6 other fields	High correlation
`gErr` is highly correlated with `u` and 6 other fields	High correlation
`rErr` is highly correlated with `u` and 6 other fields	High correlation
`iErr` is highly correlated with `uErr` and 3 other fields	High correlation
`zErr` is highly correlated with `uErr` and 3 other fields	High correlation
`uErr` is highly skewed (γ1 = 456.7235232)	Skewed
`gErr` is highly skewed (γ1 = 422.3944341)	Skewed
`rErr` is highly skewed (γ1 = 118.8801239)	Skewed
`iErr` is highly skewed (γ1 = 142.2519051)	Skewed
`zErr` is highly skewed (γ1 = 41.65436631)	Skewed

Reproduction

Analysis started	2022-02-27 19:48:40.179453
Analysis finished	2022-02-27 19:49:08.295438
Duration	28.12 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

ID
Real number (ℝ_≥0)

Distinct	265471
Distinct (%)	93.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.237664166 × 10¹⁸

Minimum	1.23764588 × 10¹⁸
Maximum	1.237680531 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	1.23764588 × 10¹⁸
5-th percentile	1.23765125 × 10¹⁸
Q1	1.237657191 × 10¹⁸
median	1.237663278 × 10¹⁸
Q3	1.237668625 × 10¹⁸
95-th percentile	1.237679435 × 10¹⁸
Maximum	1.237680531 × 10¹⁸
Range	3.465179365 × 10¹³
Interquartile range (IQR)	1.143318292 × 10¹³

Descriptive statistics

Standard deviation	9.234079428 × 10¹²
Coefficient of variation (CV)	7.460892609 × 10^-6
Kurtosis	-0.8864431604
Mean	1.237664166 × 10¹⁸
Median Absolute Deviation (MAD)	6.085945065 × 10¹²
Skewness	0.3463585308
Sum	-3.414404155 × 10¹⁸
Variance	8.526822288 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.237663783 × 10¹⁸	3	< 0.1%
1.237651754 × 10¹⁸	2	< 0.1%
1.237666089 × 10¹⁸	2	< 0.1%
1.237665572 × 10¹⁸	2	< 0.1%
1.237665583 × 10¹⁸	2	< 0.1%
1.237665583 × 10¹⁸	2	< 0.1%
1.237665584 × 10¹⁸	2	< 0.1%
1.237665584 × 10¹⁸	2	< 0.1%
1.237665584 × 10¹⁸	2	< 0.1%
1.237666089 × 10¹⁸	2	< 0.1%
Other values (265461)	284786	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	2	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%
1.237645943 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%

u
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	256277
Distinct (%)	90.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.53321096

Minimum	6.137899
Maximum	31.474758
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	6.137899
5-th percentile	18.845813
Q1	21.3885025
median	22.717176
Q3	23.931763
95-th percentile	25.6771139
Maximum	31.474758
Range	25.336859
Interquartile range (IQR)	2.5432605

Descriptive statistics

Standard deviation	2.052177283
Coefficient of variation (CV)	0.09107345094
Kurtosis	0.01793379229
Mean	22.53321096
Median Absolute Deviation (MAD)	1.261786
Skewness	-0.4307088953
Sum	6417616.213
Variance	4.2114316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21.96266	5	< 0.1%
21.968773	5	< 0.1%
22.195639	5	< 0.1%
21.830866	5	< 0.1%
22.850668	5	< 0.1%
23.249609	4	< 0.1%
24.459768	4	< 0.1%
22.973475	4	< 0.1%
22.375	4	< 0.1%
22.340986	4	< 0.1%
Other values (256267)	284762	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.137899	1	< 0.1%
7.684486	1	< 0.1%
7.85844	1	< 0.1%
8.107904	1	< 0.1%
8.174813	1	< 0.1%
8.223669	1	< 0.1%
9.046374	1	< 0.1%
9.445343	1	< 0.1%
9.599357	1	< 0.1%
9.680221	1	< 0.1%

Value	Count	Frequency (%)
31.474758	1	< 0.1%
30.669785	1	< 0.1%
30.045591	1	< 0.1%
30.029575	1	< 0.1%
29.914965	1	< 0.1%
29.584764	1	< 0.1%
29.497486	1	< 0.1%
29.22876	1	< 0.1%
29.190369	1	< 0.1%
28.978514	1	< 0.1%

g
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	253305
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.00671317

Minimum	7.446142
Maximum	32.311321
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	7.446142
5-th percentile	17.3897861
Q1	19.9706715
median	21.568672
Q3	22.33006
95-th percentile	23.342819
Maximum	32.311321
Range	24.865179
Interquartile range (IQR)	2.3593885

Descriptive statistics

Standard deviation	1.90592756
Coefficient of variation (CV)	0.09072945133
Kurtosis	0.1467433537
Mean	21.00671317
Median Absolute Deviation (MAD)	0.971749
Skewness	-0.8255987356
Sum	5982858.957
Variance	3.632559864
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.417925	5	< 0.1%
21.64337	5	< 0.1%
21.820137	5	< 0.1%
21.692204	5	< 0.1%
21.834551	5	< 0.1%
21.390749	5	< 0.1%
22.388662	5	< 0.1%
22.205276	5	< 0.1%
22.561132	5	< 0.1%
22.0459	5	< 0.1%
Other values (253295)	284757	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.446142	1	< 0.1%
8.241127	1	< 0.1%
8.685551	1	< 0.1%
8.854282	1	< 0.1%
8.879968	1	< 0.1%
9.043655	1	< 0.1%
9.541052	1	< 0.1%
9.955412	1	< 0.1%
10.04998	1	< 0.1%
10.204456	1	< 0.1%

Value	Count	Frequency (%)
32.311321	1	< 0.1%
32.180359	1	< 0.1%
32.180218	1	< 0.1%
31.12199	1	< 0.1%
31.036724	1	< 0.1%
30.37472	1	< 0.1%
30.274063	1	< 0.1%
30.004261	1	< 0.1%
29.916021	1	< 0.1%
29.698931	1	< 0.1%

r
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	253330
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.78243101

Minimum	8.510301
Maximum	30.481144
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	8.510301
5-th percentile	16.6154187
Q1	18.68987
median	20.255796
Q3	21.016758
95-th percentile	22.0144542
Maximum	30.481144
Range	21.970843
Interquartile range (IQR)	2.326888

Descriptive statistics

Standard deviation	1.724220553
Coefficient of variation (CV)	0.08715918445
Kurtosis	-0.04694511422
Mean	19.78243101
Median Absolute Deviation (MAD)	1.004759
Skewness	-0.7508721697
Sum	5634174.828
Variance	2.972936515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.397943	6	< 0.1%
20.158337	6	< 0.1%
20.431469	6	< 0.1%
20.87731	6	< 0.1%
20.49766	6	< 0.1%
21.436712	5	< 0.1%
20.907282	5	< 0.1%
20.083857	5	< 0.1%
20.986086	5	< 0.1%
21.221909	5	< 0.1%
Other values (253320)	284752	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.510301	1	< 0.1%
8.871452	1	< 0.1%
9.381433	1	< 0.1%
9.537403	1	< 0.1%
9.54484	1	< 0.1%
9.806157	1	< 0.1%
9.871026	1	< 0.1%
10.18564	1	< 0.1%
10.685715	1	< 0.1%
10.713271	1	< 0.1%

Value	Count	Frequency (%)
30.481144	1	< 0.1%
27.92935	1	< 0.1%
27.586512	1	< 0.1%
27.531603	1	< 0.1%
27.443832	1	< 0.1%
27.340242	1	< 0.1%
26.760141	1	< 0.1%
26.303787	1	< 0.1%
26.298737	1	< 0.1%
26.275991	1	< 0.1%

i
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	253727
Distinct (%)	89.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.21205481

Minimum	9.260902
Maximum	32.286316
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	9.260902
5-th percentile	16.225149
Q1	18.150341
median	19.490479
Q3	20.358361
95-th percentile	21.7069342
Maximum	32.286316
Range	23.025414
Interquartile range (IQR)	2.20802

Descriptive statistics

Standard deviation	1.700399292
Coefficient of variation (CV)	0.08850689367
Kurtosis	0.1441953057
Mean	19.21205481
Median Absolute Deviation (MAD)	1.042099
Skewness	-0.4322199542
Sum	5471727.693
Variance	2.891357752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.504345	6	< 0.1%
19.685961	5	< 0.1%
20.096962	5	< 0.1%
19.962057	5	< 0.1%
19.935677	5	< 0.1%
20.149513	5	< 0.1%
19.958929	5	< 0.1%
20.872757	5	< 0.1%
19.263306	5	< 0.1%
20.285532	5	< 0.1%
Other values (253717)	284756	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.260902	1	< 0.1%
9.45409	1	< 0.1%
9.481367	1	< 0.1%
9.785824	1	< 0.1%
10.00429	1	< 0.1%
10.210069	1	< 0.1%
10.499023	1	< 0.1%
10.601875	1	< 0.1%
10.667053	1	< 0.1%
11.098452	1	< 0.1%

Value	Count	Frequency (%)
32.286316	1	< 0.1%
31.575436	1	< 0.1%
31.350872	1	< 0.1%
31.254124	1	< 0.1%
31.156153	1	< 0.1%
31.13089	1	< 0.1%
31.073492	1	< 0.1%
30.873112	1	< 0.1%
30.720078	1	< 0.1%
30.709589	1	< 0.1%

z
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	253767
Distinct (%)	89.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.88745681

Minimum	9.688597
Maximum	29.146568
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	9.688597
5-th percentile	15.9315499
Q1	17.8106385
median	19.084158
Q3	19.972534
95-th percentile	21.5791392
Maximum	29.146568
Range	19.457971
Interquartile range (IQR)	2.1618955

Descriptive statistics

Standard deviation	1.724723968
Coefficient of variation (CV)	0.09131583912
Kurtosis	0.1293595211
Mean	18.88745681
Median Absolute Deviation (MAD)	1.044447
Skewness	-0.2580487792
Sum	5379279.912
Variance	2.974672765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.348778	6	< 0.1%
19.196115	6	< 0.1%
19.232006	5	< 0.1%
19.491114	5	< 0.1%
20.177359	5	< 0.1%
19.29693	5	< 0.1%
19.518696	5	< 0.1%
19.5366	5	< 0.1%
19.37998	5	< 0.1%
19.744009	5	< 0.1%
Other values (253757)	284755	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.688597	1	< 0.1%
10.111669	1	< 0.1%
10.138	1	< 0.1%
10.246193	1	< 0.1%
10.44339	1	< 0.1%
10.667935	1	< 0.1%
10.677568	1	< 0.1%
10.737098	1	< 0.1%
10.83986	1	< 0.1%
10.881444	1	< 0.1%

Value	Count	Frequency (%)
29.146568	1	< 0.1%
29.105049	1	< 0.1%
28.954861	1	< 0.1%
28.860327	1	< 0.1%
28.741753	1	< 0.1%
28.71353	1	< 0.1%
28.68885	1	< 0.1%
28.670599	1	< 0.1%
28.620174	1	< 0.1%
28.615345	1	< 0.1%

uErr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	232977
Distinct (%)	81.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5054286479

Minimum	0.011919
Maximum	973.115381
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.011919
5-th percentile	0.041825
Q1	0.1732585
median	0.423588
Q3	0.7323425
95-th percentile	1.2197801
Maximum	973.115381
Range	973.103462
Interquartile range (IQR)	0.559084

Descriptive statistics

Standard deviation	1.924641703
Coefficient of variation (CV)	3.80793948
Kurtosis	229236.5859
Mean	0.5054286479
Median Absolute Deviation (MAD)	0.275584
Skewness	456.7235232
Sum	143949.6169
Variance	3.704245683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.094035	9	< 0.1%
0.741354	7	< 0.1%
0.311294	6	< 0.1%
0.063306	6	< 0.1%
0.33322	6	< 0.1%
0.098549	6	< 0.1%
0.04659	6	< 0.1%
0.044189	6	< 0.1%
0.071216	6	< 0.1%
0.652707	6	< 0.1%
Other values (232967)	284743	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.011919	1	< 0.1%
0.012259	1	< 0.1%
0.012604	2	< 0.1%
0.013049	1	< 0.1%
0.013249	1	< 0.1%
0.013527	1	< 0.1%
0.013617	1	< 0.1%
0.013656	1	< 0.1%
0.013725	1	< 0.1%
0.01378	1	< 0.1%

Value	Count	Frequency (%)
973.115381	1	< 0.1%
163.304649	1	< 0.1%
115.003115	1	< 0.1%
86.184253	1	< 0.1%
70.904198	1	< 0.1%
61.491178	1	< 0.1%
53.891129	1	< 0.1%
40.433575	1	< 0.1%
22.030731	1	< 0.1%
17.775392	1	< 0.1%

gErr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	171592
Distinct (%)	60.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1664961825

Minimum	0.021987
Maximum	708.703847
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.021987
5-th percentile	0.030867
Q1	0.055475
median	0.124927
Q3	0.2062105
95-th percentile	0.4196436
Maximum	708.703847
Range	708.68186
Interquartile range (IQR)	0.1507355

Descriptive statistics

Standard deviation	1.454609655
Coefficient of variation (CV)	8.736594633
Kurtosis	199808.3339
Mean	0.1664961825
Median Absolute Deviation (MAD)	0.073422
Skewness	422.3944341
Sum	47419.27826
Variance	2.115889248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.037837	13	< 0.1%
0.033108	13	< 0.1%
0.03242	12	< 0.1%
0.029518	12	< 0.1%
0.035388	11	< 0.1%
0.038326	11	< 0.1%
0.030374	11	< 0.1%
0.033157	11	< 0.1%
0.033043	11	< 0.1%
0.038172	11	< 0.1%
Other values (171582)	284691	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.021987	1	< 0.1%
0.022127	1	< 0.1%
0.022439	1	< 0.1%
0.022488	1	< 0.1%
0.022552	1	< 0.1%
0.022594	1	< 0.1%
0.022599	1	< 0.1%
0.022654	1	< 0.1%
0.022695	1	< 0.1%
0.022697	1	< 0.1%

Value	Count	Frequency (%)
708.703847	1	< 0.1%
220.567456	1	< 0.1%
121.828836	1	< 0.1%
90.426192	1	< 0.1%
83.855285	1	< 0.1%
77.903199	1	< 0.1%
43.265003	1	< 0.1%
37.209066	1	< 0.1%
36.091322	1	< 0.1%
32.901323	1	< 0.1%

rErr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	143132
Distinct (%)	50.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1194891949

Minimum	0.034156
Maximum	39.832404
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.034156
5-th percentile	0.046127
Q1	0.063903
median	0.10137
Q3	0.1493905
95-th percentile	0.2580872
Maximum	39.832404
Range	39.798248
Interquartile range (IQR)	0.0854875

Descriptive statistics

Standard deviation	0.1375152589
Coefficient of variation (CV)	1.150859365
Kurtosis	28090.18909
Mean	0.1194891949
Median Absolute Deviation (MAD)	0.040607
Skewness	118.8801239
Sum	34031.35913
Variance	0.01891044644
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.051044	13	< 0.1%
0.060908	12	< 0.1%
0.05279	12	< 0.1%
0.044166	12	< 0.1%
0.055276	12	< 0.1%
0.056232	12	< 0.1%
0.050936	11	< 0.1%
0.053529	11	< 0.1%
0.056868	11	< 0.1%
0.050614	11	< 0.1%
Other values (143122)	284690	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.034156	1	< 0.1%
0.034476	1	< 0.1%
0.034644	1	< 0.1%
0.034697	1	< 0.1%
0.034901	1	< 0.1%
0.035019	1	< 0.1%
0.035119	1	< 0.1%
0.035207	1	< 0.1%
0.035265	1	< 0.1%
0.035289	1	< 0.1%

Value	Count	Frequency (%)
39.832404	1	< 0.1%
22.327885	1	< 0.1%
12.858185	1	< 0.1%
12.272254	1	< 0.1%
12.186537	1	< 0.1%
10.61393	1	< 0.1%
9.502449	1	< 0.1%
8.952156	1	< 0.1%
8.897392	1	< 0.1%
8.373005	1	< 0.1%

iErr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	136364
Distinct (%)	47.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1321145217

Minimum	0.033318
Maximum	66.143307
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.033318
5-th percentile	0.0578893
Q1	0.0761455
median	0.101908
Q3	0.143657
95-th percentile	0.2997737
Maximum	66.143307
Range	66.109989
Interquartile range (IQR)	0.0675115

Descriptive statistics

Standard deviation	0.2091837423
Coefficient of variation (CV)	1.583351623
Kurtosis	38116.37042
Mean	0.1321145217
Median Absolute Deviation (MAD)	0.030354
Skewness	142.2519051
Sum	37627.14057
Variance	0.04375783806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.076775	13	< 0.1%
0.068524	13	< 0.1%
0.075621	12	< 0.1%
0.076402	12	< 0.1%
0.070139	12	< 0.1%
0.141784	12	< 0.1%
0.075189	11	< 0.1%
0.090621	11	< 0.1%
0.083715	11	< 0.1%
0.06724	11	< 0.1%
Other values (136354)	284689	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.033318	2	< 0.1%
0.039556	1	< 0.1%
0.039569	1	< 0.1%
0.04054	1	< 0.1%
0.041432	1	< 0.1%
0.041443	1	< 0.1%
0.041504	1	< 0.1%
0.041734	1	< 0.1%
0.041752	1	< 0.1%
0.042023	1	< 0.1%

Value	Count	Frequency (%)
66.143307	1	< 0.1%
32.41625	1	< 0.1%
20.440717	1	< 0.1%
20.024466	1	< 0.1%
18.334789	1	< 0.1%
17.491723	1	< 0.1%
13.247561	1	< 0.1%
11.959482	1	< 0.1%
11.846359	1	< 0.1%
11.37197	1	< 0.1%

zErr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	171161
Distinct (%)	60.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2198274226

Minimum	0.044069
Maximum	47.529248
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.044069
5-th percentile	0.0796933
Q1	0.110915
median	0.151384
Q3	0.229893
95-th percentile	0.628709
Maximum	47.529248
Range	47.485179
Interquartile range (IQR)	0.118978

Descriptive statistics

Standard deviation	0.2839616411
Coefficient of variation (CV)	1.291748035
Kurtosis	4520.541349
Mean	0.2198274226
Median Absolute Deviation (MAD)	0.049726
Skewness	41.65436631
Sum	62608.38874
Variance	0.08063421359
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.146039	10	< 0.1%
0.143381	10	< 0.1%
0.128688	10	< 0.1%
0.123547	10	< 0.1%
0.10685	9	< 0.1%
0.108653	9	< 0.1%
0.105764	9	< 0.1%
0.116664	9	< 0.1%
0.115216	9	< 0.1%
0.106753	9	< 0.1%
Other values (171151)	284713	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.044069	1	< 0.1%
0.044153	2	< 0.1%
0.044297	1	< 0.1%
0.044667	1	< 0.1%
0.045021	1	< 0.1%
0.045421	1	< 0.1%
0.046718	1	< 0.1%
0.047086	1	< 0.1%
0.04752	1	< 0.1%
0.047619	1	< 0.1%

Value	Count	Frequency (%)
47.529248	1	< 0.1%
29.875302	1	< 0.1%
28.713682	1	< 0.1%
26.365085	1	< 0.1%
23.711179	1	< 0.1%
22.242674	1	< 0.1%
19.015472	1	< 0.1%
17.928994	1	< 0.1%
17.246654	1	< 0.1%
16.943693	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	ID	u	g	r	i	z	uErr	gErr	rErr	iErr	zErr
0	1237645879562928805	25.155375	22.232981	21.257841	19.889854	19.427107	1.034657	0.219033	0.206952	0.147347	0.228686
1	1237645942905504040	21.910667	19.464439	18.372978	17.955502	17.642979	0.443852	0.060666	0.064809	0.069981	0.096798
2	1237645942905635180	20.978670	20.276821	19.472305	19.232706	18.994177	0.150120	0.070810	0.076891	0.085570	0.132459
3	1237645942906224860	20.389980	19.313643	17.891615	17.415066	17.181231	0.331636	0.113295	0.092397	0.093178	0.127449
4	1237645943978721520	23.907169	23.448675	20.256517	19.163860	18.557152	1.527960	1.033415	0.177488	0.132869	0.149485
5	1237645943978787138	20.503014	19.280542	18.830477	18.559280	18.481827	0.120214	0.044740	0.061519	0.071990	0.098771
6	1237645943978787212	21.728035	19.977358	18.901865	18.379099	18.037195	0.315895	0.061951	0.063594	0.068638	0.084922
7	1237645943978787238	20.095301	18.808825	18.192244	17.883970	17.655457	0.139342	0.054625	0.073051	0.085504	0.116468
8	1237645943978852526	19.983652	18.805828	17.918039	17.496410	17.238651	0.092822	0.042239	0.054085	0.062537	0.077156
9	1237645943978852865	24.602087	21.488087	19.520910	18.921425	18.594252	0.866716	0.179641	0.090975	0.091485	0.116313

Last rows

	ID	u	g	r	i	z	uErr	gErr	rErr	iErr	zErr
284797	1237679440425582965	23.639347	22.198999	21.031853	20.623516	20.220276	1.164313	0.207720	0.168991	0.189767	0.281953
284798	1237679440425582993	25.019598	23.568682	21.386972	20.716246	20.140373	1.166885	0.510955	0.181036	0.170606	0.219201
284799	1237679440425582999	23.800091	22.663116	21.376005	21.033384	20.509428	0.758078	0.172692	0.121977	0.141194	0.193995
284800	1237679440425583065	24.128036	22.615719	22.088884	22.170218	22.780581	0.840129	0.162339	0.193105	0.295670	0.616266
284801	1237679440425583321	24.797550	24.092091	22.128248	21.591732	21.169786	0.827333	0.469421	0.201903	0.198841	0.295564
284802	1237679440425583329	24.976448	24.600201	22.031639	21.277906	21.742359	0.993866	0.745757	0.237257	0.203570	0.556340
284803	1237679440425583352	22.115126	22.939453	21.892546	21.643509	21.161491	0.297924	0.287982	0.238297	0.287231	0.418816
284804	1237679440425583393	25.053223	23.429272	21.970121	21.796354	21.764332	0.960138	0.374865	0.223337	0.289326	0.562293
284805	1237679440425583406	23.518948	23.862247	22.476570	23.323412	22.473553	0.665053	0.426565	0.271013	0.674657	0.628833
284806	1237679440425583552	23.850555	23.662268	22.625984	21.673103	20.727907	0.995684	0.475650	0.380495	0.279438	0.296898

Most frequently occurring

	ID	u	g	r	i	z	uErr	gErr	rErr	iErr	zErr	# duplicates
10069	1237663782593822805	22.283274	21.068048	20.495552	20.152773	20.320446	0.280162	0.097535	0.112381	0.128407	0.269480	3
0	1237645942905045292	21.549091	20.449072	19.491505	19.109482	19.031570	0.187775	0.064391	0.070761	0.078279	0.133099	2
1	1237645942905766350	22.381472	19.829432	19.195267	18.889847	18.783106	0.565267	0.065301	0.079979	0.087633	0.143001	2
2	1237645942906028543	21.952278	19.570076	19.224197	19.068018	19.586912	0.779489	0.104354	0.127184	0.139830	0.296508	2
3	1237645942906290775	21.619223	21.169184	19.880489	19.315659	19.067236	0.579738	0.248283	0.162171	0.133410	0.193769	2
4	1237645943433527759	22.585049	22.089539	20.596846	20.023451	19.693275	0.251315	0.131726	0.085136	0.090215	0.125546	2
5	1237645943433528154	25.503576	23.376709	21.655865	21.130768	20.611811	0.415402	0.337225	0.155960	0.161406	0.229532	2
6	1237645943976493336	21.058979	20.268528	19.704321	19.551207	19.345476	0.139671	0.059261	0.075314	0.093654	0.133140	2
7	1237645943978590448	23.604773	20.865627	19.520216	18.991688	18.603312	0.855619	0.086042	0.071080	0.075468	0.092440	2
8	1237645943978852851	23.211906	21.698839	20.068785	19.535690	19.161798	0.842152	0.182576	0.104862	0.105967	0.141706	2

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring